Error in query: select count(*) as t from tbltwar where rdate=''. ERROR: invalid input syntax for type date: "" LINE 1: select count(*) as t from tbltwar where rdate='